package com.atguigu.gmall.realtime.web.mapper;

import com.atguigu.gmall.realtime.web.bean.NameValueBean;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface TrafficSourceKeywordPageViewWindowMapper {

    @Select(" select  keyword as name,  sum(keyword_count) as value from dws_traffic_source_keyword_page_view_window" +
            " where toYYYYMMDD(stt)= #{dt}  group by keyword   ")
    public List<NameValueBean> getKeywordStat(@Param("dt") Long dt);
}
